Can you manually mount it?
Code:
sudo mount /dev/scd0 /media/cdrom
Here is a list of things to check:
Check your Bios - reboot and press F2 to make sure the cdrmom shows up in your bios
Check group permissions - go to menu>system>administration>users and groups. Unlock it and check fuse and make sure you are checked as user.
If nothing works paste the results of this command
and this command